package com.jwsoft.manager.core.dao.mapper;

import com.jwsoft.manager.common.vo.bigScreen.analysisXq.AddressOverviewXqQueryVO;
import com.jwsoft.manager.common.vo.bigScreen.analysisXq.SchoolAddressCountVO;
import com.jwsoft.manager.common.vo.bigScreen.analysisXq.StuEnrollDgxxInVO;
import com.jwsoft.manager.common.vo.bigScreen.analysisXq.StuEnrollXxhxXqnxqVO;
import com.jwsoft.manager.common.vo.eduAddress.EduAddressVO;
import com.jwsoft.manager.common.vo.eduAddress.SchoolAddressQueryVO;
import com.jwsoft.manager.common.vo.eduAddressSchool.EduAddressSchoolQueryVO;
import com.jwsoft.manager.common.vo.eduAddressSchool.EduAddressSchoolSearchVO;
import com.jwsoft.manager.common.vo.eduAddressSchool.EduAddressSchoolVO;
import com.jwsoft.manager.common.vo.eduSchool.SchoolDistrictQueryVO;
import com.jwsoft.manager.common.vo.eduSchool.SchoolDistrictVO;
import com.jwsoft.manager.core.dao.model.EduAddressSchool;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
* <p>
  * 地址学校关联表 Mapper 接口
  * </p>
*
* @author wangtao
* @since 2022-12-02
*/
@Mapper
public interface EduAddressSchoolMapper extends BaseMapper<EduAddressSchool> {
    List<EduAddressVO> getAddressNo(SchoolAddressQueryVO vo);
    List<SchoolDistrictVO> getSchoolInfo(SchoolDistrictQueryVO vo);
    List<EduAddressVO> getAddress(SchoolAddressQueryVO vo);

    List<SchoolAddressCountVO> getSchoolAddressCountVO(AddressOverviewXqQueryVO vo);

    List<StuEnrollXxhxXqnxqVO> getStuEnrollXxhxXqnxq(StuEnrollDgxxInVO vo);

    //获取学校已关联数据
    List<EduAddressSchoolVO> getAddressByGl(EduAddressSchoolSearchVO vo);
    //获取学校未联数据
    List<EduAddressSchoolVO> getAddressByNoGl(EduAddressSchoolSearchVO vo);

    /**
     * 学校本年度地址库查询
     * @param vo
     * @return
     */
    List<EduAddressSchool> querySchoolAddressByNowYear(EduAddressSchoolQueryVO vo);
}
